﻿CREATE TABLE [dbo].[Flights] (
    [FlightId]          INT             IDENTITY (1, 1) NOT NULL,
    [DepartureAirport]  VARCHAR (10)    NOT NULL,
    [ArrivalAirport]    VARCHAR (10)    NOT NULL,
    [DepartureDateTime] DATETIME        NOT NULL,
    [ArrivalDateTime]   DATETIME        NOT NULL,
    [DepartureTerminal] VARCHAR (10)    NOT NULL,
    [ArrivalTerminal]   VARCHAR (10)    NOT NULL,
    [Distance]          VARCHAR (10)    NULL,
    [TaxSurcharge]      DECIMAL (18, 2) NULL,
    [FlightStatus]      VARCHAR (10)    NULL,
    [AircraftId]        INT             NOT NULL,
    [FlightCode]        VARCHAR (10)    NOT NULL
);

